翻訳と辞書
Words near each other
・ Hallucinating Foucault
・ Hallucination
・ Hallucination (disambiguation)
・ Hallucination (short story)
・ Hallucination Engine
・ Hallucination Generation
・ Hallucination Recordings
・ Hallucination Strip
・ Halloween on Franklin Street
・ Halloween on Spooner Street
・ Halloween Party
・ Halloween Party (album)
・ Halloween Party (song)
・ Halloween Party Songs
・ Halloween pennant
Halloween Problem
・ Halloween Rain
・ Halloween Screams
・ Halloween solar storms, 2003
・ Halloween Spooktacular
・ Halloween Surprise
・ Halloween with the New Addams Family
・ Halloween, Alaska
・ Halloweenight
・ Halloweentown
・ Halloweentown (film series)
・ Halloweentown (film)
・ Halloweentown High
・ Hallowell
・ Hallowell (surname)


Dictionary Lists
翻訳と辞書 辞書検索 [ 開発暫定版 ]
スポンサード リンク

Halloween Problem : ウィキペディア英語版
Halloween Problem
In computing, the Halloween Problem refers to a phenomenon in databases in which an update operation causes a change in the physical location of a row, potentially allowing the row to be visited more than once during the operation. This could even cause an infinite loop in some cases where updates continually place the updated record ahead of the scan performing the update operation.
The potential for this database error was first discovered by Don Chamberlin, Pat Selinger, and Morton Astrahan in 1976, on Halloween day while working on a query that was supposed to give a ten percent raise to every employee who earned less than $25,000. This query would run successfully, with no errors, but when finished all the employees in the database earned at least $25,000, because it kept giving them a raise until they reached that level. The expectation was that the query would iterate over each of the employee records with a salary less than $25,000 precisely once. In fact, because even updated records were visible to the query execution engine and so continued to match the query's criteria, salary records were matching multiple times and each time being given a 10% raise until they were all greater than $25,000.
The name is not descriptive of the nature of the problem but rather was given due to the day it was discovered. As recounted by Don Chamberlin:

Pat and Morton discovered this problem on Halloween .... I remember they came into my office and said, ‘Chamberlin, look at this. We have to make sure that when the optimizer is making a plan for processing an update, it doesn’t use an index that is based on the field that is being updated. How are we going to do that?’ It happened to be on a Friday, and we said, ‘Listen, we are not going to be able to solve this problem this afternoon. Let’s just give it a name. We’ll call it the Halloween Problem and we’ll work on it next week.’ And it turns out it has been called that ever since.

== References ==

* (The 1995 SQL Reunion (Protokoll) )
* (The "Halloween Problem" for XML APIs ), Mike Champion's weblog.
* ''(archive)'' (A well-intentioned query and the Halloween Problem ), Los Alamos National Laboratory, Anecdotes, IEEE Annals of the History of Computing
* Quotation from Donald D. Chamberlin, Charles Babbage Institute, OH 329


抄文引用元・出典: フリー百科事典『 ウィキペディア(Wikipedia)
ウィキペディアで「Halloween Problem」の詳細全文を読む



スポンサード リンク
翻訳と辞書 : 翻訳のためのインターネットリソース

Copyright(C) kotoba.ne.jp 1997-2016. All Rights Reserved.